CREATE TABLE [dbo].[GroupTypeMemberStatus]
(
[GroupTypeKey] [uniqueidentifier] NOT NULL,
[GroupMemberStatusCode] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsActiveStatus] [bit] NOT NULL CONSTRAINT [DF_GroupTypeMemberStatus_IsActiveStatus] DEFAULT ((0)),
[Priority] [int] NOT NULL CONSTRAINT [DF_GroupTypeMemberStatus_Priority] DEFAULT ((0)),
[MarkedForDeleteOn] [datetime] NULL,
[GroupTypeMemberStatusKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupTypeMemberStatus] ADD CONSTRAINT [PK_GroupTypeMemberStatus] PRIMARY KEY CLUSTERED ([GroupTypeMemberStatusKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeMemberStatus] ADD CONSTRAINT [AK_GroupTypeMemberStatus] UNIQUE NONCLUSTERED ([GroupTypeKey], [GroupMemberStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeMemberStatus] ADD CONSTRAINT [FK_GroupTypeMemberStatus_GroupMemberStatusRef] FOREIGN KEY ([GroupMemberStatusCode]) REFERENCES [dbo].[GroupMemberStatusRef] ([GroupMemberStatusCode])
GO
ALTER TABLE [dbo].[GroupTypeMemberStatus] ADD CONSTRAINT [FK_GroupTypeMemberStatus_GroupTypeRef] FOREIGN KEY ([GroupTypeKey]) REFERENCES [dbo].[GroupTypeRef] ([GroupTypeKey])
GO